SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_GetAvailableFieldInfoByNo] ( @JOL_Field_No INT )
AS 
    SELECT  JOL_Field_Name,
            JOL_Field_Campus,
            JOL_Field_SeatNumber,
            JOL_Field_Money,
            JOL_Field_IsProvideMultimedia,
            JOL_Field_Remark,
            JOL_Field_AddTime,
            JOL_Field_AddUser,
            JOL_Field_UpdateTime,
            JOL_Field_UpdateUser
    FROM    dbo.JOL_AvailableField
    WHERE   JOL_Field_No = @JOL_Field_No
GO
